| Key Name |
Key Type |
Keys |
| CmEvent_CmEventID_U_C_IDX |
PrimaryKey |
TaskId |
| Fk_CmEventSyOrganizationID_SyOrganizationSyOrganizationID |
Inversion Entry |
OrganizationId |
| CmEvent_DueDate_N_N_IDX |
Inversion Entry |
TaskDueDate |
| NK_CmEventLockedBy |
Inversion Entry |
LockedByUserId |
| NK_CmEventPrevSyStaffID |
Inversion Entry |
PreviouslyAssignedToStaffId |
| CmEvent_CmEventStatusID_SyStudentID_CmEventTypeID_CmEventID_U_N_IDX |
Alternate Key |
TaskId |
| CmEvent_CmTemplateID_CmEventStatusID_DueDate_SyStudentID_PlEmployerID_N_N_IDX |
Inversion Entry |
TaskDueDate |
| CmEvent_SyStudentID_CmEventStatusID_DateLstMod_N_N_IDX |
Inversion Entry |
LastModifiedDateTime |
| CmEvent_SyStaffId_CmEventStatusId_DueDate_CmEventId_U_N_IDX |
Alternate Key |
StaffId, TaskDueDate, TaskId |
| UK_CmEvent_CmEventTypeID_CmEventStatusID_DueDate_SyStudentID_SourceSystem |
Inversion Entry |
TaskDueDate, SourceSystem |
| CmEvent_SyStaffId_CmTemplateID_CmEventStatusId_DueDate_CmEventId_U_N_IDX |
Alternate Key |
StaffId, TaskDueDate, TaskId |
| CmEvent_plEmployerId_CmEventStatusID_DueDate_CmEventId_CmEventTypeId_U_N_IDX |
Alternate Key |
TaskDueDate, TaskId |
| Entity Name |
Type |
Cardinality |
Business Name |
VerbPhrase |
InversePhrase |
Foreign Keys |
Is Supertype |
| Staff |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StaffId |
NO |
| Attachment |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
AttachmentId |
NO |
| ClassSection |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
ClassSectionId |
NO |
| Staff |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StaffId |
NO |
| Staff |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StaffId |
NO |
| Employer |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
EmployerId |
NO |
| EmployerContact |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
EmployerContactId |
NO |
| EmployerJob |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
PlEmployerJobID |
NO |
| Attachment |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
AttachmentId |
NO |
| Campus |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
SessionSyCampusID |
NO |
| SyOrganizationContact |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
OrganizationContactId |
NO |
| SyOrganization |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
OrganizationId |
NO |
| Staff |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
LockedByUserId |
NO |
| Staff |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
PreviouslyAssignedToStaffId |
NO |
| Staff |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StaffId |
NO |
| ProspectInquiry |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
ProspectInquiryId |
NO |
| Student |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentId |
NO |
| StudentEnrollmentPeriod |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentEnrollmentPeriodId |
NO |
| SyOrganization |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
OrganizationId |
NO |
| SyOrganizationContact |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
OrganizationContactId |
NO |
| TaskResult |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
TaskResultId |
NO |
| TaskStatus |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
TaskStatusId |
NO |
| TaskTemplate |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
TaskTemplateId |
NO |
| TaskType |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
TaskTypeId |
NO |